SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394018 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394018 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (306216,481122,848110,69535,579244,220767,852200,323706,319654,798391,474749,60331,647755,212953,402490,618801,1038966,579226,593300,605034,877363,707163,374443,475164,799684,466261,949099,1008998,245704,1045846,769549,125132,416011,548839,22980,919625,435894,663612,641871,669455,631973,902809,195402,682255,96411,624959,900077,860511,1047387,778113,296477,892721,52304,514772,32042,960491,538063,923811,683025,129115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]