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` = 176590 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 176590 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009648,424507,100076,858059,68646,1006673,349869,686207,704330,23190,448903,312990,391648,616378,962280,904826,260234,1021302,525175,448812,790531,1017562,812829,779365,222491,798910,453300,39788,121160,555684,661729,774443,460966,29263,719004,911850,139725,96159,532272,738349,448507,626021,220771,125292,674552,604741,641548,522682,878625,448165,790844,560893,51257,224612,645129,606182,551679,524703,248089,18011) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 176590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 176590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]