SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415055 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415055 [ RunTime:0.001605s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026013,743849,587869,498400,55683,708957,209531,236403,953987,283593,647117,687383,734314,594081,156784,847471,627630,604046,138713,1002730,341043,1034361,558124,107990,337338,498293,1046138,390714,405123,589805,202856,604526,353631,130642,79476,375978,584685,25416,571561,135682,49155,443144,299263,210279,379202,833375,181400,878472,249092,583897,514734,1002017,770502,487472,86151,550798,351562,792565,679041,179232) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415055 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415055 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]