SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541912 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541912 [ RunTime:0.005227s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960798,703206,669702,1019534,557990,939145,804376,361323,424577,518085,894775,889125,604284,777704,642569,300952,647464,821305,508034,320064,619635,289532,498683,485725,314269,317988,682471,425751,657462,25001,714000,359303,1036045,95663,490195,732839,317788,614893,38378,441301,95943,796502,105872,976011,143027,363856,129932,904134,437748,513094,208166,904355,322032,460499,331971,957947,988583,939844,506966,436151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]