SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265010 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265010 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208897,233521,166546,421456,930017,273425,1043489,523742,700862,704001,676334,306777,409907,489005,438444,849964,137312,445515,750384,786058,718464,600145,192544,705785,1031930,190569,934289,336541,541314,1024543,247867,794506,722772,476697,84206,755483,518684,687171,255693,810341,887673,448446,29158,147550,269460,229466,826148,902472,714741,565639,719314,360993,184840,749116,958528,640536,692996,781037,700399,93738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]