SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001728s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480102 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480102 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961977,405801,1001547,200739,497535,560725,38922,667143,965675,695646,747420,65937,829312,707315,409983,61601,496262,82289,972227,298027,501069,516569,485131,785587,568868,139115,9648,223023,274171,469461,25849,147653,282455,394210,170671,799028,351483,61151,889196,60462,748827,36327,737105,62489,493996,618956,746331,786065,207314,270555,158458,735232,108388,582970,122933,723941,660111,85057,672527,221517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]