SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001330s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454183 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454183 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045753,1046213,488960,898584,1046768,876564,159532,45150,669291,542814,753516,808011,859192,750052,309770,935253,343597,505518,611170,4243,848443,41001,616271,754006,424315,967439,199516,6201,151654,505145,843417,972371,933494,1046452,783674,547921,542340,848018,549351,283248,798068,524970,316049,901510,532414,825813,595000,733288,504970,751887,683518,327656,244343,59293,1036990,909890,111579,67828,491974,789200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000581s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]