SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016294 LIMIT 1 [ RunTime:0.003786s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016294 [ RunTime:0.004553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369024,539041,672373,990196,961586,1014094,930469,16298,261363,349894,457369,106785,984668,577486,5651,732426,650544,117438,336880,693626,348827,814053,836951,141093,111959,960382,674504,308651,212779,403770,258251,493288,169855,250954,932213,550297,693506,471258,317233,98348,142780,719694,665289,549650,759778,218952,775471,164179,1040434,463812,152361,78512,708265,570911,731016,315671,552089,409909,237043,729030) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016294 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016294 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]