SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319405 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319405 [ RunTime:0.002592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (186650,389617,616320,54448,76440,837894,489218,968454,29445,851127,714637,681464,631576,643555,824930,195389,89741,328099,740184,1003596,184360,549765,264255,529359,669856,896294,1004980,625964,812184,529260,987961,930938,205079,824720,571510,431375,576742,316756,902058,319840,432688,179664,379272,533180,644299,138383,879424,988635,614953,110303,213543,242131,34201,455779,562985,125693,792671,93786,209886,124812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]