SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501941 LIMIT 1 [ RunTime:0.000549s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501941 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (520908,470631,54484,975857,440240,878622,482339,799325,307496,116782,5199,795802,575289,423026,981083,896378,927426,821926,164223,454643,877206,735564,247031,44636,707313,838898,1018304,121939,548633,763094,657939,883035,659826,68688,259815,504014,624152,614633,646744,1013223,240539,775317,964613,804873,144759,853013,850532,640029,494520,721299,513427,499730,468118,354512,255806,323242,791505,733807,588892,661049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001628s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]