SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452809 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452809 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667409,495677,625351,184873,465085,541523,592407,997637,166371,691836,735273,374385,850845,131690,821423,737859,671157,317801,480591,329304,943590,840898,673300,462947,689460,559690,244115,385525,599479,1001184,153421,378926,772845,9335,631676,738172,664660,284860,673397,621726,556681,48787,391094,272421,710293,303566,744920,376057,817911,477799,710770,326955,445259,967404,578614,321686,207596,519573,616920,972710) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]