SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102015 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102015 [ RunTime:0.003350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (398857,916914,909668,379434,263870,748164,557373,972816,687252,207305,446634,797745,510711,65553,243704,476657,400951,508810,6663,435865,642315,483374,208399,674968,908311,85042,300680,455576,137112,904114,1024061,764342,944705,347229,191862,949471,593505,713406,28811,14328,860285,41165,265131,1044805,320519,321323,129065,120994,739507,251195,333226,816592,38317,915723,178374,933948,964609,688666,114423,928343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000665s ]