SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031610 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031610 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865841,1013323,15578,204256,421678,147395,560391,72133,1036585,332182,177634,510463,913313,818640,386539,641601,112371,1007951,811023,767170,506129,9938,704867,738983,876662,764369,327757,423514,172216,526191,8706,879179,88531,594407,951482,679487,445068,264949,162559,56347,480620,420805,793827,191776,588804,969852,314272,168284,721706,35838,236418,283768,15792,732973,793775,753649,1023255,682897,769340,654695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001220s ]