SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039746 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039746 [ RunTime:0.001565s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048655,576941,896321,1027967,719826,844821,857121,494621,61642,277196,165949,1025982,594066,961851,288880,346835,626454,354422,827030,741361,341761,523511,822796,171016,65861,686883,152730,928388,2327,338827,324869,521190,252209,155699,618619,745092,859208,644000,549119,11280,658219,296421,534586,207085,123882,155561,429304,879737,948496,923967,338288,499359,702496,1042231,338329,942844,511485,199266,853272,796315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000936s ]