SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254428 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254428 [ RunTime:0.002590s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495821,426885,205563,1009661,887998,889825,276216,839445,545784,59506,1041719,118898,600839,928811,783721,819217,286174,474657,153561,367151,615634,845906,476512,579494,400642,192064,120628,798485,144397,397447,293967,829639,561818,670653,593391,913373,874889,34206,755058,950704,239461,981880,893215,1020820,391126,491879,116458,270843,49718,42263,252796,175541,1012510,600479,81656,624921,171922,86737,350147,88451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001835s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000823s ]