SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450967 LIMIT 1 [ RunTime:0.000477s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450967 [ RunTime:0.002041s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (911917,1010055,16083,1038614,845669,929963,452930,313792,1030063,744085,352982,661177,409174,789316,681142,759056,930468,591089,273277,508927,523399,294765,1005848,156102,851856,850981,309750,405368,488662,918517,1016879,988487,681980,438614,359306,377461,806412,841909,833699,1005064,999526,795175,654283,157230,796335,23435,588560,473635,55110,687903,397981,969965,794712,400613,425923,188895,421634,633835,176061,483882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450967 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450967 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]