SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 457176 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 457176 [ RunTime:0.002448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (613338,835765,554026,507504,28989,141669,919149,929985,661481,334609,399127,676212,472750,424168,166871,672938,793326,633888,208015,291827,671934,865571,926004,857468,30939,1031440,79154,720691,28993,906973,293734,709867,916484,813714,657197,485124,1033466,277142,847768,533645,306219,735469,48755,519354,177328,436970,671443,822728,146269,610068,178550,635050,539610,109904,721521,737477,27222,287495,926010,1036576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 457176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 457176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]