SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286207 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286207 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293299,288347,449378,169099,1012394,1008549,803993,496025,645388,448233,299025,512504,481695,925601,474930,312806,500565,231744,802763,441282,214384,526519,974134,736650,779224,501975,993089,200178,222927,423398,636073,907345,534026,255526,53542,885081,418745,981531,293079,14412,849189,536897,629226,467047,22301,596000,806734,907771,326774,163625,276489,945870,345014,674006,467570,693836,882494,692640,585312,1003954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286207 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286207 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]