SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428585 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428585 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50211,155496,179357,36146,803729,170170,328350,809052,136915,514395,787321,658752,773207,710063,420667,843151,119931,131098,125784,1000775,443323,337400,493294,626421,286520,685522,55527,286917,301880,688726,371222,42700,590836,505596,759341,814119,201336,119937,489433,716669,82835,692584,96275,879198,602251,169206,601006,61912,3822,745333,858060,640037,894900,518515,265305,347640,1022063,435826,1012322,379866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428585 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428585 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]