SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102506 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102506 [ RunTime:0.003420s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814783,549521,202548,56578,853788,953985,121778,639862,810825,67367,70359,990362,823248,875220,480438,121011,473322,176334,373094,688162,109648,41723,868034,636585,172027,920996,996316,202826,355829,40092,1039846,520524,753582,978336,706467,518536,706491,937421,421598,519466,574084,559779,782511,348614,405869,667913,634989,1021269,242275,24182,992571,339419,128987,800634,587890,135805,792625,789158,428695,1017157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]