SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 210300 LIMIT 1 [ RunTime:0.002407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 210300 [ RunTime:0.003904s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295822,742954,316721,335005,467372,204966,664001,398650,361849,702089,5032,392,6682,147542,111828,263533,352008,466546,397952,108682,852275,547801,437673,132030,100294,312903,769274,718891,323250,301633,1022037,493688,455863,872658,183513,320837,1045096,886576,823959,588754,790357,984935,413988,205038,291527,407642,695490,777567,866932,866995,204805,873991,574246,323400,642471,843816,297407,717972,1005055,410159) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 210300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 210300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]