SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002628 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002628 [ RunTime:0.002144s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763696,329716,952546,319418,196935,275112,259469,814905,389690,6635,1037722,561866,535444,351697,78758,81522,933483,559896,634458,237473,569249,115186,336842,471226,45093,297559,425831,639776,46047,1027661,374554,555019,276837,320510,849841,885554,465283,611995,633800,948316,802407,480071,758917,850070,928975,773204,742459,669347,56801,245712,947996,718767,491088,39241,616567,221627,975300,962099,967423,336289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]