SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320179 LIMIT 1 [ RunTime:0.000295s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320179 [ RunTime:0.002752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70302,739994,466930,1010106,147204,786896,732736,277323,979445,783666,926753,283051,473029,879547,569627,4626,575549,587636,695974,650309,328400,157791,44243,384353,121824,864544,612893,851775,735418,727738,894070,328514,55594,887522,477081,505864,928791,91896,761473,822228,1028796,50367,764557,876242,195360,699875,643468,124446,906683,464344,801284,120238,623897,22606,414958,673650,947547,807187,91273,132380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002225s ]