SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502089 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502089 [ RunTime:0.002836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332454,136356,77271,331371,200793,420583,663640,760579,862387,554338,411078,3711,663416,1013283,333259,432051,807224,109037,115340,354072,863633,891387,176257,311440,559150,498110,245973,301059,913884,799471,1033285,1019355,748838,412659,182715,120958,271269,520352,165865,958622,893959,937793,212084,218762,505723,1018097,296085,446720,973750,206922,178646,459561,900809,687303,475236,735561,441554,193854,732429,995239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]