SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527160 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527160 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432638,523715,1048292,153108,126247,275907,1005491,536345,531435,985938,688024,44995,137609,837853,178192,790351,523821,401096,910453,741728,580160,613671,615252,469789,450341,205860,781696,57956,15124,237216,552492,643840,302517,58383,359432,500975,871428,163082,493930,412650,529036,510123,85585,432771,516206,45806,263059,853262,242950,584425,810075,970676,350158,163018,670829,920757,150464,627957,318098,1008097) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]