SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303522 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303522 [ RunTime:0.001693s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523115,655164,472648,184123,280549,106245,226440,9982,379310,277161,740544,657881,348417,794772,107517,981471,1025478,172575,1033485,769495,759231,1041759,502442,890510,463680,158393,381546,632900,544363,922863,350105,144466,481872,412439,384528,763781,294053,899958,1026160,504818,919346,383338,603849,1022231,437161,740804,904965,214006,256147,363431,957115,68522,265817,422217,362209,94245,324648,607621,475065,419594) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]