SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566584 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566584 [ RunTime:0.002506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (659334,537790,953640,210450,106689,777632,356736,414152,250722,448021,82497,599765,329032,463400,1041877,195500,565600,233477,1005507,1022540,783315,490607,493878,210050,470113,225732,162309,798561,131602,409956,842468,722423,738058,262154,949639,309797,772721,112345,387911,514221,393281,35825,698476,571592,696450,662056,308964,74506,897065,462382,693967,935901,163079,120973,600047,899775,915100,1042353,178247,400814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]