SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475783 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475783 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555341,366467,185623,116737,1006869,403743,835603,828517,997195,761194,59847,1028680,780307,161194,896817,232578,1014138,833170,959822,621846,50672,754427,223707,272657,536414,667226,183297,595027,1042696,329913,67313,842718,59532,360868,555369,740501,81453,726320,675050,252461,864358,1036009,160880,534335,648079,275725,373370,181387,421616,982528,375653,368540,373841,879613,597311,534861,744147,754964,558293,1026793) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475783 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475783 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]