SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401946 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401946 [ RunTime:0.001532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034783,654339,143985,733018,436304,514154,354856,171333,534927,229991,1043765,685889,380383,689890,602447,181887,900639,596029,507167,429949,1015734,325378,466926,131491,338387,593169,140635,110269,248143,35808,363913,662134,7516,397928,854395,724030,410229,907959,902513,734453,320221,131867,1013965,575795,793647,102057,439079,761729,82249,558107,13016,487171,673416,365069,645141,584374,115961,759662,923780,502418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]