SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301818 LIMIT 1 [ RunTime:0.000433s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301818 [ RunTime:0.002658s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677373,260142,181202,996661,731878,532255,488342,807788,930246,156482,592088,836693,1040501,472229,641595,988523,106089,214668,772616,1014923,178749,63796,347883,356064,102949,743580,248365,529160,969240,95331,796236,503863,1031014,831011,982271,390332,829200,565034,601205,121150,203229,543455,181310,191467,404814,545819,571924,428880,999503,159792,596797,854644,229455,1015485,89915,673835,1044808,742184,747950,544692) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]