SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026243 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026243 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398315,174736,426890,825743,832,683808,548961,290058,211178,581428,207985,276125,1014825,782385,619135,963081,209782,919921,186362,264708,17803,666042,489802,983941,684993,968637,870716,95734,551433,528718,995378,523753,194824,521789,686953,105800,452713,632229,627838,508624,464736,12680,485901,796046,760998,428020,39215,118292,1028122,293167,771372,722139,164241,710500,896501,408814,633367,608511,670386,796994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]