SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023651 LIMIT 1 [ RunTime:0.002961s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023651 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (357917,133686,635113,1039042,630439,414442,199034,545232,148808,610721,693378,546828,478617,271034,829779,282769,925360,1046868,841052,148721,486256,706227,475683,891188,176346,885033,772798,696724,511004,617202,828013,117829,550290,852927,874361,242649,179441,253670,1037410,220026,593479,487030,257870,275107,487782,270604,230620,563681,1024776,730099,134115,301691,208968,1025217,207335,650204,538771,52845,882349,747090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001007s ]