SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104327 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104327 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (718326,795080,475676,354703,260890,368793,323673,94038,415251,754632,410499,1024185,64315,261667,709914,880684,680427,630655,527888,612845,365588,616853,704682,530314,191034,280349,152965,973440,162579,400340,646242,973140,56140,545808,135494,239625,4905,173667,930366,683206,561836,370119,40057,220032,202700,659122,322196,1007168,998877,619345,365331,997940,151610,1018882,504940,526063,312908,482794,701264,393925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]