SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434239 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434239 [ RunTime:0.001789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036538,192737,938190,379187,1040856,1037085,624888,721724,303433,63099,94746,68782,464968,437303,254019,570754,242353,108537,553180,237087,238565,119848,49486,136420,582270,452513,46686,24288,180218,281114,713042,503343,944426,1025748,177363,226155,231025,684776,330935,262780,841597,836056,475354,385522,539922,579629,304868,67541,336843,166620,254944,524742,27159,133700,498419,983668,733943,832013,437721,958056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]