SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018395 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018395 [ RunTime:0.003961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173314,480357,28839,303978,554750,716697,632178,814471,629483,425828,458672,816343,1047902,120108,516640,997053,1001373,688542,75230,447469,1008815,525352,68662,228024,1027657,854697,625934,25993,812761,303782,981088,284412,516949,254156,189451,521698,535380,287773,421631,858735,80003,492632,989473,349332,214176,157262,107366,592299,594784,1000071,945384,644335,308403,267800,519688,348322,382404,933454,842716,613842) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018395 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018395 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]