SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 380101 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 380101 [ RunTime:0.001778s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107466,376610,765554,740947,529287,922119,695604,673170,576726,863846,1009749,815286,238762,284461,282793,676673,452934,83811,715341,162611,550531,345234,26263,359620,268970,212652,502543,231571,869906,202079,46567,323405,278768,131250,896360,804206,57391,789430,552148,313032,43934,210194,265534,71900,723837,426402,713469,465092,643286,330659,481151,324652,264183,208401,888927,463146,44027,832264,485999,284972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 380101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 380101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]