SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420860 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420860 [ RunTime:0.002825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603992,543846,858265,92041,440876,127686,691406,931446,453581,842257,133302,622963,952612,216843,785868,406259,363164,966865,1029792,632156,576829,1009841,506702,649822,164083,414385,135098,910903,442817,780402,950178,1041344,872786,228266,177748,443192,961867,997093,467032,1010896,379338,361724,938635,772468,299179,906621,543420,510858,377909,914035,855509,488559,888042,464935,436056,543384,78274,802528,318064,867641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001085s ]