SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 253681 LIMIT 1 [ RunTime:0.000706s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 253681 [ RunTime:0.002420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883658,745287,679731,408134,609117,655038,864743,47618,1020065,191129,708048,321249,17678,22284,170931,980437,389255,576208,170485,462770,805497,261368,277661,551116,166420,1021643,40628,157281,357597,511582,1000110,896328,374381,345677,661193,705859,22549,962573,420832,895430,722556,967232,1021539,754716,166208,407289,176173,289615,982531,993261,35617,497098,798002,50266,656769,49920,869868,120818,1034853,504404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 253681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 253681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]