SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584896 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584896 [ RunTime:0.002102s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149860,754954,488120,75138,220527,917602,989887,572083,906217,17613,60070,743136,118814,441947,928452,980506,338446,110937,59165,1012183,304766,852442,953357,196710,788733,22167,403274,972096,1036035,377526,521913,292333,656243,609379,797601,949196,652830,572430,669423,853924,518161,350682,655177,784983,681319,547065,394018,301624,1019291,835456,853064,124111,477422,461799,504116,792030,145628,879047,477398,477631) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]