SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020327 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020327 [ RunTime:0.005161s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235203,632055,486472,944849,885668,162448,151800,474414,6808,743029,17872,691414,281218,314923,796866,136068,468518,438498,734774,665983,168014,322405,52705,719977,726841,848987,684947,724999,419581,245513,761176,1030411,818599,323056,486226,927142,92361,107667,370713,675260,568604,362853,66144,815688,302367,445337,895510,993950,414709,239776,77346,141941,488016,1010867,641089,703181,503280,874535,407313,59950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]