SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313416 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313416 [ RunTime:0.002449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902870,2939,668254,565301,672977,863647,439650,839329,220597,225830,231421,1030843,814383,276880,744664,102398,22037,794783,799325,917603,65835,590326,551676,99718,921512,337618,607102,562419,581535,1005803,712149,193260,560419,733442,788530,288580,479987,121544,159184,10509,710132,815443,832786,855932,564090,14280,1048679,40669,107916,741004,637231,15808,755291,701859,762097,18943,348074,866451,944561,267130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]