SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546812 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546812 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030783,485944,908743,513668,476722,1013406,667106,77755,957692,284704,858933,541910,641487,811065,481870,731049,312184,994875,288375,777069,511875,343721,874601,38614,299572,203738,143007,459684,301076,148515,891303,865944,789678,350444,214021,308445,261979,317026,422683,305398,888858,749435,104394,980313,984635,232020,819802,620987,764895,195761,176268,235802,82369,681976,767335,254624,1004503,24213,594969,695607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000473s ]