SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001742s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021701 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021701 [ RunTime:0.003507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340729,50109,626707,873047,80051,708634,1011519,133172,743012,556481,563337,325701,354112,554791,834360,446219,1014743,280841,404858,364919,791750,278293,1043802,287283,1048818,865720,390506,13989,55381,428785,845179,747328,864874,771982,180275,112789,1014041,141740,188976,2787,81642,77644,765544,612800,580705,186807,729539,90945,932585,686188,997251,15665,834461,430275,382685,978646,241308,578156,22195,945355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]