SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 603809 LIMIT 1 [ RunTime:0.001871s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 603809 [ RunTime:0.004196s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485018,889142,406854,275267,810421,487684,842478,298251,991814,514596,991963,721173,1023644,461589,219321,746304,180376,1039454,8640,981757,362292,250907,237389,286625,22693,87391,358138,543060,766267,219748,46469,326730,849278,145890,133330,1010186,57922,1043618,531327,253886,517864,816656,323953,867921,175147,1001572,1017238,638085,699131,922198,855961,144774,497334,669187,905188,171543,440415,356248,388525,849110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 603809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005695s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 603809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]