SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505351 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505351 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981743,101072,162352,846522,478437,453498,56544,690007,41660,107205,943778,825472,856641,492184,393228,1045103,168293,983377,684948,403996,1035539,806548,333364,972554,638397,365845,150564,372790,479578,571642,267949,42446,96642,357631,382676,56543,342827,65465,766754,744334,951218,678140,599509,944313,327925,778361,713851,866593,523897,216287,669486,32665,657862,192189,495691,742781,278477,332855,1038190,581328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]