SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028024 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028024 [ RunTime:0.002728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572209,302277,451351,255892,545088,185972,578390,28396,130955,418,359653,969436,916291,301817,446710,193522,292627,979587,352708,797804,366613,113699,989337,494438,501412,957610,928615,327361,193664,96778,379717,937452,656055,774793,677660,247136,375214,769581,651300,136148,812278,219878,947464,936861,638724,381026,751029,676226,458663,411814,399555,176211,404075,231031,426981,118820,461918,803486,655913,570378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006550s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000574s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]