SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002571s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403731 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403731 [ RunTime:0.002452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773577,448020,717201,608429,67015,760852,1042197,153739,653229,875639,450734,477634,302008,325199,769060,35962,103161,873357,867550,517944,421900,102730,1033128,790408,840468,542941,804341,375924,465590,418809,553464,814683,568577,337180,185628,244717,211101,205693,435845,1020832,301060,125091,453843,987662,773579,595841,894183,505400,176791,591683,756872,460579,707079,684258,295195,74482,927134,732394,570084,287666) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]