SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 175118 LIMIT 1 [ RunTime:0.000578s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 175118 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585238,803636,67002,266031,850452,359813,284210,6197,530662,549500,182286,819355,171291,233694,104873,982683,128381,670092,825807,986864,672270,46541,397678,897513,779092,496679,396144,498625,226392,240622,935340,236965,311252,822237,121609,832687,840059,978015,118948,751945,722917,188726,47038,543741,758670,442755,905537,355410,150490,138480,497831,347520,233390,713700,878466,672376,587671,163785,489895,592442) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 175118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 175118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]