SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454550 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454550 [ RunTime:0.001545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010816,1034481,1030951,362329,873605,208689,377794,100522,785302,803953,805394,95837,138080,447695,387644,597859,297590,650242,53596,643002,496850,452073,259670,561804,943509,732659,918273,611745,542924,265936,736860,317610,513502,913657,910998,665183,720069,275870,851434,380599,483560,325608,74592,662618,298988,384397,100617,121255,329533,285609,822593,22880,750767,627266,277857,248283,671885,90094,1015742,968947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454550 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454550 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]