SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002820s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020138 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020138 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147276,592448,1010047,317641,748300,723536,71551,915249,53670,597394,509729,517246,846864,578561,683475,271857,266762,145458,831000,441300,529618,776590,91352,135890,172777,579953,221514,177175,806939,233992,501103,817929,902617,139284,61987,606610,946711,1009631,295593,1002500,459063,86809,1010971,717825,459040,253662,882145,44654,910344,775907,500627,349284,778787,650880,711500,884765,538682,550516,778849,1046812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]