SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006651s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508243 LIMIT 1 [ RunTime:0.003492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508243 [ RunTime:0.003186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816171,66538,915064,705635,662693,1021560,601742,546754,992835,623354,970613,236150,458122,313104,1032201,738937,808956,280040,95415,1048497,439496,518478,829329,456808,875454,118286,28688,1041264,740791,469338,955428,576920,948450,429396,795736,374926,96404,900735,465388,668775,467162,1046171,377218,491013,590296,47048,607541,416646,930453,509842,171490,135114,1002278,98342,271650,1022774,393319,971586,461847,177228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000658s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001000s ]