SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541535 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541535 [ RunTime:0.003664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941544,664129,774815,211588,961161,855213,634472,860891,737790,570333,784675,855938,384464,50366,505045,58884,709002,729887,982226,366233,77835,127611,893316,860743,311892,283261,891267,36989,525881,939177,598437,202271,257434,363004,125397,1033002,393057,970496,682273,170159,418065,548872,148086,143177,9468,996792,873081,675392,171169,100706,80733,735216,624352,407425,574631,944870,50979,664116,1025817,1023049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]