SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583516 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583516 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509072,547393,311972,460936,147384,428541,701331,558005,695505,869007,436387,189540,193347,209947,857341,534998,906825,395158,466981,108474,655766,231738,305904,246663,717353,938640,150702,1046144,625378,8472,1029265,948545,260181,139228,299419,136031,705922,820047,767708,1020450,614465,604350,84290,348670,352578,174743,348111,827113,456280,271069,50533,434426,366523,413177,34980,513068,875046,173991,366454,263889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]