SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 597943 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 597943 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141877,66853,860686,987532,53378,100713,588780,406840,734010,592398,772103,412818,317775,753162,417242,595561,85018,436321,457476,371391,14762,439063,254777,483116,489402,192776,42498,654092,750120,852140,289826,937322,484337,495405,501463,700200,6913,625431,327807,81135,846150,849699,839848,1047168,479390,144009,651102,465527,456502,621213,579940,826879,71332,567754,546594,777347,390664,279574,363877,215969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 597943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 597943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]