SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 383993 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 383993 [ RunTime:0.001800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294448,487300,707622,648424,743388,364497,888214,781017,444168,551508,701906,460279,591850,54604,941682,925026,541311,825178,802122,209648,486568,173771,79926,915772,494333,726009,148999,939197,850627,854867,156183,763639,584036,581550,265969,53264,283610,950274,277371,411369,744830,15505,505504,1047019,455066,529143,1033463,599948,853341,1005435,77433,497995,769322,739488,144633,584163,561535,703850,707588,752632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 383993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 383993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]