SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199936 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199936 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644427,1044514,93721,428861,658992,332067,832662,741109,453827,855592,1057,652664,189942,144255,590081,301690,325318,274745,445049,606681,238790,791342,947002,24270,379114,291645,208387,701357,100498,741411,236145,302060,914185,764819,576761,128612,154916,938350,674570,854071,630204,766357,244244,53857,912448,662261,567367,991383,96385,669161,252106,807398,200131,996698,298559,128979,6944,426713,878315,666228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]