SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502523 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502523 [ RunTime:0.001708s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (794318,957250,56001,769222,398908,115777,8863,233695,98847,901701,326584,762364,895783,53119,101706,517564,364145,240344,1013312,902391,559218,1021976,1025941,263923,627321,697201,49782,732285,179382,76262,794185,820507,284503,977630,498129,554034,139804,715096,123424,139628,403324,653002,226967,731920,471872,51284,900332,1003308,333769,194527,505121,887922,227579,563580,850900,510021,671756,47329,567115,1021798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]