SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458914 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458914 [ RunTime:0.001720s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046446,858061,46407,340529,287630,123867,498552,161047,466473,360272,691710,947080,851361,924133,609068,490321,408196,961730,1017475,968442,746864,650801,308267,239059,688190,442538,245579,163215,331412,982452,85384,975419,168478,102577,209088,472197,502821,351090,293918,80289,149143,185064,27018,931718,845857,261315,598764,99724,705055,777862,100945,206561,653884,671479,273757,864475,945796,1013399,161681,974466) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]