SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511803 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511803 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (920734,500833,550865,682835,576004,449126,280988,339331,478357,1036376,599007,983041,109330,889813,679264,874713,23216,212911,563543,459724,683192,172180,639101,1011779,288728,534433,792518,191592,442971,440800,178817,15543,416773,152318,1009497,81857,178958,78126,381852,405048,182606,818051,459911,1027130,565059,522167,581991,776483,26326,596437,544700,171197,429787,224159,327748,509067,94118,735371,715248,139555) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]