SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254188 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254188 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401888,664174,136542,439106,731370,42228,860244,933646,57316,85104,106500,369964,958002,648947,504062,893510,678346,857491,433211,867595,998171,238929,610598,773946,510631,668944,914788,999039,700348,821366,1000035,859781,636127,655072,327884,93083,569669,692537,893868,623831,522522,673606,34759,811624,303498,941394,693790,577049,242471,861519,646009,127561,470604,933798,876216,323841,875736,1045935,749286,291732) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000707s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]