SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405797 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405797 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (652829,1017852,313841,876729,93133,304916,718282,69813,963030,568578,13804,184702,892350,641911,496328,304271,36886,644532,1039378,752018,659008,1012701,644635,867265,64365,793105,749935,152605,466941,765923,79476,124634,345069,1002917,852092,146733,1036691,391401,775040,156740,277878,701679,423736,1042474,225914,843484,963557,676333,958886,682207,924939,633045,247604,331787,832353,248378,193783,404824,932305,878915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405797 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405797 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001331s ]