SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100423 LIMIT 1 [ RunTime:0.000895s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100423 [ RunTime:0.002924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (731652,1034981,389352,57443,530485,522552,715653,25510,481501,61237,366069,937345,597608,697059,144202,812126,77553,996082,731711,321205,508377,124185,617832,638038,381121,178650,886181,202557,923368,932709,863894,95658,170370,669531,1002651,267644,429031,532194,699278,524388,58239,642155,930966,21407,87381,594094,80714,785927,779274,863410,432951,542844,986720,268865,1046645,544364,532611,80242,113011,913249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000842s ]