SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28618 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28618 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177185,548983,910719,693551,147989,650574,506629,1017483,809836,723837,710487,386541,90708,213829,87437,266274,816702,731022,171971,22425,381933,391365,568773,757013,911015,354488,613676,756556,1042811,314382,208235,878949,767139,572312,363268,590848,750673,750400,171941,523238,629117,964996,424519,341874,249612,809732,352795,208714,334526,62923,150063,47869,903070,803719,697882,549339,522377,819278,808251,691469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000953s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28618 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28618 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]