SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522964 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522964 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908967,868393,573233,1023790,895228,698062,614930,239075,509331,270082,11650,289991,247978,284296,689184,263469,298422,848076,473374,763222,180843,316578,131180,617749,312052,710164,799770,736533,893967,677496,471003,895454,863472,1033583,710058,623238,716160,472743,356874,52918,1033716,943803,1036816,291999,749290,282670,620530,229103,854486,585311,497001,533301,848032,688492,818299,107042,766840,316811,872209,840733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]