SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541895 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541895 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619670,673490,482048,787245,922004,960146,959941,845544,109110,552710,715011,367139,871679,234861,602196,654525,387355,265694,1036957,1025528,425340,51183,916317,432608,727331,682088,917784,848624,357353,620707,526868,385579,458226,799682,521319,220397,528551,523239,645514,9842,522001,260411,350392,577237,949776,720896,167705,695299,899272,868480,244240,828531,829811,122584,875075,342955,650952,260807,241230,770539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]