SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310410 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310410 [ RunTime:0.002351s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326669,658811,558938,450666,482715,785993,41078,400991,481036,774777,559798,643679,248837,981357,276792,464991,1006079,725936,446403,343579,778368,890999,988199,60542,413314,367418,934894,1038874,538949,660804,733989,777276,515335,133244,389230,365795,501441,198311,860709,98896,866114,29770,849838,936926,802801,210330,137308,839033,438211,851013,928482,670497,217766,401054,216857,635451,627154,465013,392473,19948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002619s ]