SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 872150 LIMIT 1 [ RunTime:0.000487s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 872150 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510565,28309,883622,258756,52134,864356,150884,412000,241964,25469,703202,550780,886989,771866,885192,552678,594113,387283,845679,707896,336965,649493,878954,292982,1033398,1008183,825788,60324,131721,754909,913285,312111,436114,942360,683551,880556,131140,618328,468750,802143,590737,473899,991357,171682,734823,894582,482544,679795,604237,346560,642876,534590,717432,348584,503687,740589,639784,747988,364469,557891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001555s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 872150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 872150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]