SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 68987 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 68987 [ RunTime:0.001995s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532030,755601,466494,151117,690422,725303,62861,15221,380207,324137,598873,457106,1001950,65773,965650,1000390,185386,982579,402121,501564,72151,874190,914222,140308,656311,290312,545158,700635,665187,261450,551201,119840,963642,482060,956309,637521,295607,693029,916689,729054,755341,454685,397211,222454,733367,866714,759321,476424,258747,863910,505105,808355,490621,416612,801535,487580,405437,344063,332008,257032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 68987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 68987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002228s ]