SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493513 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493513 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022552,763964,756947,891553,77180,52818,713423,249786,908137,323104,29290,846435,425290,444781,956362,954683,470890,247496,174657,39183,611638,156541,221807,926528,362748,960516,901012,20611,988209,327830,188580,203634,872875,554681,454627,670919,678805,37996,652802,1027965,477531,623264,845544,711179,961581,112201,889891,544642,191936,670298,1042527,904344,620940,67980,387309,253071,102496,109465,223771,745262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]