SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595535 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595535 [ RunTime:0.001776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121093,815292,367182,796224,261830,321906,958963,642653,520596,13918,559990,775998,174107,247637,72778,877508,192800,832910,818416,269326,854863,509104,245876,682173,319038,943313,257098,911436,993011,929754,498204,860695,151989,559341,155183,963346,47548,387184,329415,28691,657323,20172,544851,884933,802661,359406,206594,263986,886286,522517,815045,377992,844850,482685,643543,517978,639436,678300,752410,711999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.019744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001884s ]