SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820066 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820066 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (246291,184771,88979,712673,970002,97033,286590,487291,300594,687056,357963,396395,191980,713133,596333,895457,214600,189753,658153,499580,411758,818193,259389,639330,313630,243087,876780,746304,652465,173765,451093,165696,174730,1026670,880792,644025,869243,725675,195410,749438,964010,1013951,162597,932467,456306,736825,881590,1025193,635125,33883,931802,443099,1033494,194739,868338,728219,722857,85203,839728,90542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001882s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820066 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820066 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]